# -*- coding: utf-8 -*-
import cx_Oracle
con = cx_Oracle.connect('gis/ndtvgis@192.168.20.79/GIS')
print con.version
cursor = con.cursor()
 
cursor.execute("select * from tegjd where bm=:bm",{'bm':'HS.ZFY/SQY/GJD01'})
rows=cursor.fetchall()
for row in rows:
    print row
    
cursor.execute("select * from tegjd where bm like :bm",{'bm':'HS.ZFY/SQY/GJD%'})
for result in cursor:
    print result[0],result[1],result[2]
cursor.close()
con.close()